create procedure dbo.[Desafiliar]
(@id BIGINT)
as
UPDATE [dbo].[Persona]
   SET [Afiliado] = 0
 WHERE [ID]=@id;